John Jonassen

Overview

Overview
Roles	Member
Badges	15

About Me
Not much happening here, yet.

140

Posts

347

Visits

250

Points

May 19, 2020

Join Date

Aug 29, 2024

Last Active

Re: Is anyone else having trouble with the Today function?

John Jonassen

10/27/20

Two parts on this: 1) Your first formula attempt should be =IF(Cell@232="2",Today(),"") omitting the = sign before "Today", this should clear up your invalid operation. …

1 ·
Re: Using a countif formula across sheets

John Jonassen

10/27/20

Have you tried =COUNTIF({7.1 Staff}, "Bocquet")+COUNTIF({7.2 Staff}, "Bocquet")?

1 ·
Re: Working on creating an IF statement that has multiple conditions to be met.

John Jonassen

10/14/20

Hi @Ian Abee , Give this formula a try: =IF(Progress@row = "Complete", "Blue", IF(AND([Start Date]@row <= TODAY(), Progress@row = "Not Started"), "Yellow", …

1 ·
Re: concatenating dates

John Jonassen

09/30/20

Try this =[BHI Cell1] + YEAR(Date1) + "." + MONTH(Date1) + "." + DAY(Date1)

1 ·
Re: COUNTIF to determine the number of tickets created in a given month.

John Jonassen

09/24/20

Try this: =COUNTIFS([Created Date]:[Created Date], >=DATE(2020, 5, 1), [Created Date]:[Created Date], <=DATE(2020, 5, 31))

2 ·